SELECT
CAST([RunId] AS INT),
CAST(REPLACE([OfsLe], '"', '') AS VARCHAR(25)),
CAST(REPLACE([OfsLeDesc], '"', '') AS VARCHAR(240)),
CAST(REPLACE([IsBankChain], '"', '') AS VARCHAR(1))
 FROM stg.AsiaRefOfsBankChainEntity